﻿TBList="ICC_ABAUFM;ICC_ABPOSFS;";
 DROP TABLE ICC_ABPOSFS
GO
  CREATE TABLE "INTEX"."ICC_ABPOSFS"
   (
        "KRS" CHAR(2),
        "LFD" CHAR(6),
        "SEASON" CHAR(5),
        "SECTION" CHAR(10),
        "ART" CHAR(20),
        "VAR" CHAR(3),
        "FARBE" CHAR(10),
        "PHOTO" CHAR(200),
        "CDES" VARCHAR2(60 CHAR),
        "ARTDES" VARCHAR2(60 CHAR),
        "EXTPRODUCER" CHAR(10),
        "STARTDAT" NUMBER(8),
        "DELDAT" NUMBER(8),
        "ETDDAT" NUMBER(9),
        "AETDDAT" NUMBER(9),
        "CAPP" CHAR(3),
        "SMAPP" CHAR(3),
        "SZAPP" CHAR(3),
        "WAPP1"  CHAR(3),
        "WAPP2"  CHAR(3),
        "WAPP3"  CHAR(3),
        "WAPP4" CHAR(3),
        "WAPP5"  CHAR(3),
        "WAPP6"  CHAR(3),
        "WAPP7"  CHAR(3),
        "WAPP8"  CHAR(3),
        "AAPP1"  CHAR(3),
        "AAPP2"  CHAR(3),
        "AAPP3"  CHAR(3),
        "AAPP4"  CHAR(3),
        "AAPP5"  CHAR(3),
        "AAPP6" CHAR(3),
        "AAPP7"  CHAR(3),
        "AAPP8"  CHAR(3),
        "WCHECK"  CHAR(3),
        "EXTTECH"  CHAR(20),
        "FPRICE" NUMBER(9,3),
        "TQTY" NUMBER(9),
        "REMARK" VARCHAR2(200 CHAR),
         "S" NUMBER(9),
         "M" NUMBER(9),
         "L" NUMBER(9),
         "XL" NUMBER(9)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA"

GO